UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HVU7PpvoCaG305dBJ40OEONl7W/1jvEUqyEHXnSD2s0='
WHERE
key_id = 'daa1915d5b55abdfc8a8a9f2ac03ca3497339223ee44278aff68e0a803ccf4ec'
AND (
token = 'HVU7PpvoCaG305dBJ40OEONl7W/1jvEUqyEHXnSD2s0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)