UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/4KYrJxsyh6KL9DlzRn6exEp9xDXW1mtwu31DN2FEHA='
WHERE
key_id = '80ca836e19274f9acfde57b513f8aff70a505f8cfab19e4bbc9b70f9aae4a078'
AND (
token = '/4KYrJxsyh6KL9DlzRn6exEp9xDXW1mtwu31DN2FEHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)