UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ROK+rhR+jBESBXr7I1hnNCb8w2KGIxDRdjP+/7pchag='
WHERE
key_id = 'aa84783f03e370814b41a9541dc138ba289fa6ff19eb03cbb0c1d050c40b8677'
AND (
token = 'ROK+rhR+jBESBXr7I1hnNCb8w2KGIxDRdjP+/7pchag='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)