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