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