UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QrEBWWwq/5B6ymTa2l4bWSZ0N1tqpVXIfR7jptz0AQc='
WHERE
key_id = 'c4b7cbc87ef6fb402cfed2c29854ee6872457880da4403fdf584f9366f83c7c2'
AND (
token = 'QrEBWWwq/5B6ymTa2l4bWSZ0N1tqpVXIfR7jptz0AQc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)