UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gP/nk+K+R0ETY6gvFbD1cID4BlmZgQCmBIjAoHzFlOs='
WHERE
key_id = 'db8377f9eadd690560ae740354ad7d27aae1804e5d0d0511d1b7ec705049ccba'
AND (
token = 'gP/nk+K+R0ETY6gvFbD1cID4BlmZgQCmBIjAoHzFlOs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)