UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x3H7uMecE4c50i3rwviaIQlWu3ZeJEtkZPgxUAEs8X0='
WHERE
key_id = 'a8cac422fd6b1654cdac86e0000556e85ff18129d21687e3f83ff0a49d8c17ad'
AND (
token = 'x3H7uMecE4c50i3rwviaIQlWu3ZeJEtkZPgxUAEs8X0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)