UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D/j1m4doLuyGseoRUyCxA0NFbbx+hSGozoyalSTeKac='
WHERE
key_id = '3cf9e4fc66114f90f61c132207bb09585a846e9c71c35444a63d85d42ba63142'
AND (
token = 'D/j1m4doLuyGseoRUyCxA0NFbbx+hSGozoyalSTeKac='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)