UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VfFhgg11YQGtilv5YcVRflqSEsbaJJZuK5VScSMi3xU='
WHERE
key_id = '43f31eba66f29df8e293cf7460093c964eb18cf6fc241db4e0f1ee2cdc9a4c65'
AND (
token = 'VfFhgg11YQGtilv5YcVRflqSEsbaJJZuK5VScSMi3xU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)