UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NA4SrcUhorhgfNd8k6/0QfrppsYtcHhEKKqMDQ1k6ZE='
WHERE
key_id = '8b495a7a2e2d21f4b67e79eeeae111c2da8712f71d0cc74bb3503add869bb9fd'
AND (
token = 'NA4SrcUhorhgfNd8k6/0QfrppsYtcHhEKKqMDQ1k6ZE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)