UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8NmDh3ggvibHCr/ZoG2PfRixK5F69DS+w0DBuBOtQH4='
WHERE
key_id = 'dd77ed2b9fc09a6d4698f97d9b7770049d69199b7fdbc65589ab1fede156368a'
AND (
token = '8NmDh3ggvibHCr/ZoG2PfRixK5F69DS+w0DBuBOtQH4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)