UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Cb30xN98r5oIB6UApfj8b0wIyRU2uRFKBBPOD9x4jUE='
WHERE
key_id = '05d74b643338d74e84519e1e361a4bcca4ee1a36a619053ce092a9e9070800ce'
AND (
token = 'Cb30xN98r5oIB6UApfj8b0wIyRU2uRFKBBPOD9x4jUE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)