UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eYlOOR4zFymjshvHiYLe8ZfCDit5P1mEpD3PwH4MKBw='
WHERE
key_id = 'b22220cc43dab2fe5af7a6935861361d35b9aa0f51a6d55a9e018ac9ee35721d'
AND (
token = 'eYlOOR4zFymjshvHiYLe8ZfCDit5P1mEpD3PwH4MKBw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)