UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zjbTLBH94bJJbF+wxRpwyvErN4V1ehOyRgn5Bg5qzT4='
WHERE
key_id = 'a28c01c902021e160a72d171838392da2a3cf6a59711e05ad6b4a94269b021e8'
AND (
token = 'zjbTLBH94bJJbF+wxRpwyvErN4V1ehOyRgn5Bg5qzT4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)