UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7thD0YCEtlPU4WWYKB4P1r83DA4gqcANsWGYxyoqEFM='
WHERE
key_id = 'c574d2826e0f0bf4c0048aa2fb12f5e860b2bab9a12eafe16159b969f35a3a7e'
AND (
token = '7thD0YCEtlPU4WWYKB4P1r83DA4gqcANsWGYxyoqEFM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)