UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z0fl22nkrDiQ6V2CgX8VNfgrVM4I+A9yCKVkQOW0AMg='
WHERE
key_id = 'f41a8ca0c05f2b5e87456fac5821d249b1d8778f538b473d8dd4517988073550'
AND (
token = 'Z0fl22nkrDiQ6V2CgX8VNfgrVM4I+A9yCKVkQOW0AMg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)