UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0tpCOHc64HX7q5rRkfeLhcGcEVMVUEsCEvVkUQadRTs='
WHERE
key_id = '923a4e112e52939ff6b71fa321bb6e8c9e31f94072845243cba165e6c7395d39'
AND (
token = '0tpCOHc64HX7q5rRkfeLhcGcEVMVUEsCEvVkUQadRTs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)