UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VTMglnMbFwXLAYGNh9//3rgLWXZ9AcxiipLShBu2W+E='
WHERE
key_id = 'd49417a0944523fdd80c32acbbe2b7636a731f8e569e4598a8462edeb5d7fd08'
AND (
token = 'VTMglnMbFwXLAYGNh9//3rgLWXZ9AcxiipLShBu2W+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)