UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z1HFI+TcFnjSvnkK5Ou4wGxCYIREI5FCL9Y3TocINyY='
WHERE
key_id = 'c2dec52b9b8109b451c957c234b274821a00910ae8af1b2cea2d464af4b4bb85'
AND (
token = 'z1HFI+TcFnjSvnkK5Ou4wGxCYIREI5FCL9Y3TocINyY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)