UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hCgHUMX5VUpyF2z+iSbjQYX665cy7KEL9C603/7OaEU='
WHERE
key_id = 'a9b0afda736ea833b88f756647732f9321df5556ae12082e787cf4ca85772e24'
AND (
token = 'hCgHUMX5VUpyF2z+iSbjQYX665cy7KEL9C603/7OaEU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)