UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lcTgI1qMRtDWHR2ULDlgBIOQDaNC3zI6QaZmljk1Nbk='
WHERE
key_id = '538c0f7711ec667d5b14c9e2db7231fda4305cc9c00190041441a11762a81ab3'
AND (
token = 'lcTgI1qMRtDWHR2ULDlgBIOQDaNC3zI6QaZmljk1Nbk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)