UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6BCiGOFf3JC2sMRIBt1n8/vDGEW6I5746BVmeY1JzMk='
WHERE
key_id = '1952691f7f658596d52af1e61fe27c27dad143a43be3ebf0b79b827d15da4cfc'
AND (
token = '6BCiGOFf3JC2sMRIBt1n8/vDGEW6I5746BVmeY1JzMk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)