UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k6hzGCqIKNTPLNE88dYfn8ZUqgvfAK3p1dZdTMKjtZs='
WHERE
key_id = '27eae6877cf4277d65836264f047e350f4c940f7bcbe094cc68a2494996d1cd3'
AND (
token = 'k6hzGCqIKNTPLNE88dYfn8ZUqgvfAK3p1dZdTMKjtZs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)