UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SA+tYnCp6av7RrrlTYT/44sZ9JRba8McSe1OkLd3s4k='
WHERE
key_id = '7de29bc0a79f64c47f46661999b09a9c624df3d57f76b107522a537db2f3b9f8'
AND (
token = 'SA+tYnCp6av7RrrlTYT/44sZ9JRba8McSe1OkLd3s4k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)