UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VEChZr8cSbWU4etEUbIEwwVVEZzOCDlMfFRsMIwYa54='
WHERE
key_id = '8e5c49036150d9a0f9230dfd05ff9e96754236ec85e57c43825b05b631824faf'
AND (
token = 'VEChZr8cSbWU4etEUbIEwwVVEZzOCDlMfFRsMIwYa54='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)