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