UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yQUIxGk+tExUlkl+3Y1bfRJvHlXgELe6Gc06FJo9Q14='
WHERE
key_id = 'd8eef33c225e4ad89ca87c37df8f5188b2d3af402b91a923b057c412a2a85049'
AND (
token = 'yQUIxGk+tExUlkl+3Y1bfRJvHlXgELe6Gc06FJo9Q14='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)