UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'scCQjk7aYCH4P/gGLW4ASQvDwphfA1b142Vp6JVpKsM='
WHERE
key_id = '3f57143191db306f2c7f7190ac678e909680646ab3097f738eac506ec3becd0e'
AND (
token = 'scCQjk7aYCH4P/gGLW4ASQvDwphfA1b142Vp6JVpKsM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)